CREATE TABLE [dbo].[Product_Function]
(
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Function_PRODUCT_CODE] DEFAULT (''),
[FUNCTION_TYPE] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Function_FUNCTION_TYPE] DEFAULT (''),
[BEGIN_DATE_TIME] [datetime] NULL,
[END_DATE_TIME] [datetime] NULL,
[SEQ] [int] NOT NULL CONSTRAINT [DF_Product_Function_SEQ] DEFAULT ((0)),
[MINIMUM_ATTENDANCE] [int] NOT NULL CONSTRAINT [DF_Product_Function_MINIMUM_ATTENDANCE] DEFAULT ((0)),
[EXPECTED_ATTENDANCE] [int] NOT NULL CONSTRAINT [DF_Product_Function_EXPECTED_ATTENDANCE] DEFAULT ((0)),
[GUARANTEED_ATTENDANCE] [int] NOT NULL CONSTRAINT [DF_Product_Function_GUARANTEED_ATTENDANCE] DEFAULT ((0)),
[ACTUAL_ATTENDANCE] [int] NOT NULL CONSTRAINT [DF_Product_Function_ACTUAL_ATTENDANCE] DEFAULT ((0)),
[SETTINGS] [int] NOT NULL CONSTRAINT [DF_Product_Function_SETTINGS] DEFAULT ((0)),
[SETUP_DATE_TIME] [datetime] NULL,
[POST_DATE_TIME] [datetime] NULL,
[AUTO_ENROLL] [bit] NOT NULL CONSTRAINT [DF_Product_Function_AUTO_ENROLL] DEFAULT ((0)),
[PRINT_TICKET] [bit] NOT NULL CONSTRAINT [DF_Product_Function_PRINT_TICKET] DEFAULT ((0)),
[LAST_TICKET] [int] NOT NULL CONSTRAINT [DF_Product_Function_LAST_TICKET] DEFAULT ((0)),
[CEU_TYPE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Function_CEU_TYPE] DEFAULT (''),
[CEU_AMOUNT] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_Function_CEU_AMOUNT] DEFAULT ((0)),
[COURSE_CODE] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Function_COURSE_CODE] DEFAULT (''),
[OTHER_TICKETS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Function_OTHER_TICKETS] DEFAULT (''),
[CEU_ENTERED] [bit] NOT NULL CONSTRAINT [DF_Product_Function_CEU_ENTERED] DEFAULT ((0)),
[MAXIMUM_ATTENDANCE] [int] NOT NULL CONSTRAINT [DF_Product_Function_MAXIMUM_ATTENDANCE] DEFAULT ((0)),
[PARENT] [bit] NOT NULL CONSTRAINT [DF_Product_Function_PARENT] DEFAULT ((0)),
[CONFLICT_CODE] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Function_CONFLICT_CODE] DEFAULT (''),
[WEB_ENABLED] [bit] NOT NULL CONSTRAINT [DF_Product_Function_WEB_ENABLED] DEFAULT ((0)),
[WEB_MULTI_REG] [tinyint] NOT NULL CONSTRAINT [DF_Product_Function_WEB_MULTI_REG] DEFAULT ((0)),
[SQUARE_FEET] [numeric] (15, 2) NULL,
[IS_FR_ITEM] [bit] NOT NULL CONSTRAINT [DF_Product_Function_IS_FR_ITEM] DEFAULT ((0)),
[IS_GUEST_FUNCTION] [bit] NOT NULL CONSTRAINT [DF_Product_Function_IS_GUEST_FUNCTION] DEFAULT ((0)),
[CREATE_DETAIL_ACTIVITY] [bit] NOT NULL CONSTRAINT [DF_Product_Function_CREATE_DETAIL_ACTIVITY] DEFAULT ((0)),
[EVENT_TRACK] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Function_EVENT_TRACK] DEFAULT (''),
[EVENT_CATEGORY] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Function_EVENT_CATEGORY] DEFAULT (''),
[IS_EVENT_REGISTRATION_OPTION] [bit] NOT NULL CONSTRAINT [DF_Product_Function_IS_EVENT_REGISTRATION_OPTION] DEFAULT ((0)),
[TIME_STAMP] [timestamp] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Product_Function] ADD CONSTRAINT [PK_Product_Function] PRIMARY KEY CLUSTERED ([PRODUCT_CODE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Product_Function] TO [IMIS]
GRANT SELECT ON  [dbo].[Product_Function] TO [IMIS]
GRANT INSERT ON  [dbo].[Product_Function] TO [IMIS]
GRANT DELETE ON  [dbo].[Product_Function] TO [IMIS]
GRANT UPDATE ON  [dbo].[Product_Function] TO [IMIS]
GO